<!DOCTYPE html>
<!-- saved from url=(0050)https://www.cnblogs.com/simple1025/p/11151882.html -->
<html lang="zh-cn" style="--olcb-folder-code-block-max-height:80vh;"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta name="referrer" content="origin-when-cross-origin">
    <meta name="description" content="我们测试过程中，经常需要执行升级脚本或导入生产测试数据，对于轻量的升级脚本可以直接在客户端工具中打开执行，但是对于文件内容比较大的.sql文件，比如几百M，几G的sql文件，直接拖到客户端工具打开执行">
    <meta property="og:description" content="我们测试过程中，经常需要执行升级脚本或导入生产测试数据，对于轻量的升级脚本可以直接在客户端工具中打开执行，但是对于文件内容比较大的.sql文件，比如几百M，几G的sql文件，直接拖到客户端工具打开执行">
    <meta http-equiv="Cache-Control" content="no-transform">
    <meta http-equiv="Cache-Control" content="no-siteapp">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>linux上执行mysql的脚本文件 - simplesally - 博客园</title>
    <link id="favicon" rel="shortcut icon" href="https://common.cnblogs.com/favicon.svg" type="image/svg+xml">
    
    <style>#home :not(.cnblogs_code):not(.cnblogs_Highlighter)>pre:not([highlighted]):not([class*="brush:"]) code:not(.hljs), :not(.cnblogs_code):not(.cnblogs_Highlighter)>pre:not([highlighted]):not([class*="brush:"]) code:not(.hljs) {background: rgb(245, 245, 245);
        padding: 12px;
        border: 1px solid rgb(204, 204, 204);
        border-radius: 3px;
        border-color: transparent;
        color: rgb(68, 68, 68);
        font-family: "Courier New", sans-serif;
        font-size: 12px</style><link rel="stylesheet" href="./linux上执行mysql的脚本文件_files/blog-common.min.css">
    

    <link id="MainCss" rel="stylesheet" href="./linux上执行mysql的脚本文件_files/bundle-loveisintheair.min.css">
        <link id="highlighter-theme-cnblogs" type="text/css" rel="stylesheet" href="./linux上执行mysql的脚本文件_files/cnblogs.css">
    
    
    <link id="mobile-style" media="only screen and (max-width: 767px)" type="text/css" rel="stylesheet" href="./linux上执行mysql的脚本文件_files/bundle-loveisintheair-mobile.min.css">
    
    <link type="application/rss+xml" rel="alternate" href="https://www.cnblogs.com/simple1025/rss">
    <link type="application/rsd+xml" rel="EditURI" href="https://www.cnblogs.com/simple1025/rsd.xml">
    <link type="application/wlwmanifest+xml" rel="wlwmanifest" href="https://www.cnblogs.com/simple1025/wlwmanifest.xml">
    <script type="text/javascript" async="" src="./linux上执行mysql的脚本文件_files/analytics.js"></script><script>
        var currentBlogId = 524061;
        var currentBlogApp = 'simple1025';
        var isLogined = false;
        var isBlogOwner = false;
        var skinName = 'LoveIsIntheAir';
        var visitorUserId = '';
        var hasCustomScript = false;
        try {
            if (hasCustomScript && document.referrer && document.referrer.indexOf('baidu.com') >= 0) {
                Object.defineProperty(document, 'referrer', { value: '' });
                Object.defineProperty(Document.prototype, 'referrer', { get: function(){ return ''; } });
            }
        } catch(error) { }
        window.cb_enable_mathjax = false;
        window.mathEngine = 0;
        window.codeHighlightEngine = 1;
        window.enableCodeLineNumber = false;
        window.codeHighlightTheme = 'cnblogs';
        window.darkModeCodeHighlightTheme = 'vs2015';
        window.isDarkCodeHighlightTheme = false;
        window.isDarkModeCodeHighlightThemeDark = true;
        window.isDisableCodeHighlighter = false;
        window.enableCodeThemeTypeFollowSystem = false;
    </script>
        <script>
            var currentPostDateAdded = '2019-07-08 16:11';
        </script>
    <script src="./linux上执行mysql的脚本文件_files/jquery-2.2.0.min.js"></script>
    <script src="./linux上执行mysql的脚本文件_files/blog-common.min.js"></script><style>.medium-zoom-overlay {
  position: fixed;
  top: 0;
  right: 0;
  bottom: 0;
  left: 0;
  opacity: 0;
  transition: opacity 300ms;
  will-change: opacity;
}

.medium-zoom--opened .medium-zoom-overlay {
  cursor: pointer;
  cursor: zoom-out;
  opacity: 1;
}

.medium-zoom-image {
  cursor: pointer;
  cursor: zoom-in;
  /*
    The `transition` is marked as "!important" for the animation to happen
    even though it's overriden by another inline `transition` style attribute.

    This is problematic with frameworks that generate inline styles on their
    images (e.g. Gatsby).

    See https://github.com/francoischalifour/medium-zoom/issues/110
   */
  transition: transform 300ms cubic-bezier(0.2, 0, 0.2, 1) !important;
}

.medium-zoom-image--hidden {
  visibility: hidden;
}

.medium-zoom-image--opened {
  position: relative;
  cursor: pointer;
  cursor: zoom-out;
  will-change: transform;
}
</style><script id="hljs-script" src="./linux上执行mysql的脚本文件_files/highlight.min.js" type="text/javascript" async=""></script>
    

    
<meta http-equiv="origin-trial" content="A+cA2PUOfIOKAdSDJOW5CP9ZlxONy1yu+hqAq72zUtKw4rLdihqRp6Nui/jUyCyegr+BUtH+C+Elv0ufn05yBQEAAACFeyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiUHJpdmFjeVNhbmRib3hBZHNBUElzIiwiZXhwaXJ5IjoxNjY5NzY2Mzk5LCJpc1N1YmRvbWFpbiI6dHJ1ZSwiaXNUaGlyZFBhcnR5Ijp0cnVlfQ=="><meta http-equiv="origin-trial" content="A+zsdH3aNZT/bkjT8U/o5ACzyaeNYzTvtoVmwf/KOilfv39pxY2AIsOwhQJv+YnXp98i3TqrQibIVtMWs5UHjgoAAACLeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiUHJpdmFjeVNhbmRib3hBZHNBUElzIiwiZXhwaXJ5IjoxNjY5NzY2Mzk5LCJpc1N1YmRvbWFpbiI6dHJ1ZSwiaXNUaGlyZFBhcnR5Ijp0cnVlfQ=="><meta http-equiv="origin-trial" content="AxceVEhIegcDEHqLXFQ2+vPKqzCppoJYsRCZ/BdfVnbM/sUUF2BXV8lwNosyYjvoxnTh2FC8cOlAnA5uULr/zAUAAACLeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXRhZ3NlcnZpY2VzLmNvbTo0NDMiLCJmZWF0dXJlIjoiUHJpdmFjeVNhbmRib3hBZHNBUElzIiwiZXhwaXJ5IjoxNjY5NzY2Mzk5LCJpc1N1YmRvbWFpbiI6dHJ1ZSwiaXNUaGlyZFBhcnR5Ijp0cnVlfQ=="><script src="./linux上执行mysql的脚本文件_files/pubads_impl_2022102001.js" async=""></script><link rel="preload" href="./linux上执行mysql的脚本文件_files/f(2).txt" as="script"><script type="text/javascript" src="./linux上执行mysql的脚本文件_files/f(2).txt"></script></head>
<body class="skin-loveisintheair has-navbar">
<a name="top"></a>
<div id="top_nav" class="navbar forpc">
    <nav id="nav_main" class="navbar-main">
        <ul id="nav_left" class="navbar-list navbar-left">
            <li class="navbar-branding">
                <a href="https://www.cnblogs.com/" title="开发者的网上家园" role="banner">
                    <img src="./linux上执行mysql的脚本文件_files/logo.svg" alt="博客园Logo">
                </a>
            </li>
            <li>
                <a href="https://www.cnblogs.com/" onclick="countClicks(&#39;skin-navbar-sitehome&#39;)">首页</a>
            </li>
            <li>
                <a href="https://news.cnblogs.com/" onclick="countClicks(&#39;nav&#39;, &#39;skin-navbar-news&#39;)">新闻</a>
            </li>
            <li>
                <a href="https://q.cnblogs.com/" onclick="countClicks(&#39;nav&#39;, &#39;skin-navbar-q&#39;)">博问</a>
            </li>
            <li>
                <a id="nav_brandzone" href="https://brands.cnblogs.com/" onclick="countClicks(&#39;nav&#39;, &#39;skin-navbar-brands&#39;)">专区</a>
            </li>
            <li>
                <a href="https://ing.cnblogs.com/" onclick="countClicks(&#39;nav&#39;, &#39;skin-navbar-ing&#39;)">闪存</a>
            </li>
            <li>
                <a href="https://edu.cnblogs.com/" onclick="countClicks(&#39;nav&#39;, &#39;skin-navbar-edu&#39;)">班级</a>
            </li>
        </ul>
        <ul id="nav_right" class="navbar-list navbar-right">
            <li>
                <form id="zzk_search" class="navbar-search" action="https://zzk.cnblogs.com/s" method="get" role="search">
                    <input name="w" id="zzk_search_input" placeholder="代码改变世界" type="search" tabindex="3">
                    <button type="submit" id="zzk_search_button">
                        <img src="./linux上执行mysql的脚本文件_files/search.svg" alt="搜索">
                    </button>
                </form>
            </li>
            <li id="navbar_login_status" class="navbar-list">
                <a class="navbar-user-info navbar-blog" href="https://i.cnblogs.com/EditPosts.aspx?opt=1" alt="写随笔" title="写随笔" style="display: none;">
                    <img id="new_post_icon" class="navbar-icon" src="./linux上执行mysql的脚本文件_files/newpost.svg" alt="写随笔">
                </a>
                <a id="navblog-myblog-icon" class="navbar-user-info navbar-blog" href="https://passport.cnblogs.com/GetBlogApplyStatus.aspx" alt="我的博客" title="我的博客" style="display: none;">
                    <img id="myblog_icon" class="navbar-icon" src="./linux上执行mysql的脚本文件_files/myblog.svg" alt="我的博客">
                </a>
                <a class="navbar-user-info navbar-message navbar-icon-wrapper" href="https://msg.cnblogs.com/" alt="短消息" title="短消息" style="display: none;">
                    <img id="msg_icon" class="navbar-icon" src="./linux上执行mysql的脚本文件_files/message.svg" alt="短消息">
                    <span id="msg_count" style="display: none"></span>
                </a>
                <a id="navbar_lite_mode_indicator" data-current-page="blog" style="display: none" href="javascript:void(0)" alt="简洁模式" title="简洁模式启用，您在访问他人博客时会使用简洁款皮肤展示">
                    <img class="navbar-icon" src="./linux上执行mysql的脚本文件_files/lite-mode-on.svg" alt="简洁模式">
                </a>
                <div id="user_info" class="navbar-user-info dropdown" style="display: none;">
                    <a class="dropdown-button" href="https://home.cnblogs.com/">
                        <img id="user_icon" class="navbar-avatar" src="./linux上执行mysql的脚本文件_files/avatar-default.svg" alt="用户头像">
                    </a>
                    <div class="dropdown-menu">
                        <a id="navblog-myblog-text" href="https://passport.cnblogs.com/GetBlogApplyStatus.aspx">我的博客</a>
                        <a href="https://home.cnblogs.com/">我的园子</a>
                        <a href="https://account.cnblogs.com/settings/account">账号设置</a>
                        <a href="javascript:void(0)" id="navbar_lite_mode_toggle" title="简洁模式会使用简洁款皮肤显示所有博客">
    简洁模式 <img id="navbar_lite_mode_on" src="./linux上执行mysql的脚本文件_files/lite-mode-check.svg" class="hide"><span id="navbar_lite_mode_spinner" class="hide">...</span>
</a>
                        <a href="javascript:void(0)" onclick="account.logout();">退出登录</a>
                    </div>
                </div>
                <a class="navbar-anonymous" href="https://account.cnblogs.com/signup" style="display: inline;">注册</a>
                <a class="navbar-anonymous" href="javascript:void(0);" onclick="account.login()" style="display: inline;">登录</a>
            </li>
        </ul>
    </nav>
</div>




<!--done-->
<center>
<div id="home">
<div id="header">
	<div id="blogTitle">
	<a href="https://www.cnblogs.com/simple1025/"><img id="blogLogo" src="./linux上执行mysql的脚本文件_files/logo.gif" alt=""></a>			
		
<!--done-->
<h1><a id="Header1_HeaderTitle" class="headermaintitle HeaderMainTitle" href="https://www.cnblogs.com/simple1025/">simplesally</a>
</h1>
<h2>简单，快乐，勇敢，真实</h2>




		
	</div><!--end: blogTitle 博客的标题和副标题 -->
	<div id="navigator">
		
<ul id="navList">
	<li><a id="blog_nav_sitehome" class="menu" href="https://www.cnblogs.com/">
博客园</a>
</li>
	<li>
<a id="blog_nav_myhome" class="menu" href="https://www.cnblogs.com/simple1025/">
首页</a>
</li>
	<li>

<a id="blog_nav_newpost" class="menu" href="https://i.cnblogs.com/EditPosts.aspx?opt=1">
新随笔</a>
</li>
	<li>
<a id="blog_nav_contact" class="menu" href="https://msg.cnblogs.com/send/simplesally">
联系</a></li>
	<li>
<a id="blog_nav_admin" class="menu" href="https://i.cnblogs.com/">
管理</a>
</li>
	<li>
<a id="blog_nav_rss" class="menu" href="javascript:void(0)" data-rss="https://www.cnblogs.com/simple1025/rss/">
订阅</a>
	
<a id="blog_nav_rss_image" href="https://www.cnblogs.com/simple1025/rss/">
    <img src="./linux上执行mysql的脚本文件_files/xml.gif" alt="订阅">
</a></li>
</ul>


		<div class="blogStats">
			
			<!--done-->
随笔- 14&nbsp;
文章- 0&nbsp;
评论- 10&nbsp;
阅读- 
<span title="总阅读数: 71794">
71794</span>&nbsp;



			
		</div><!--end: blogStats -->
	</div><!--end: navigator 博客导航栏 -->
</div><!--end: header 头部 -->

<div class="clear"></div>
	<div id="topicList">
		<div id="post_detail">
<!--done-->
<div id="topics">
	<div class="post">
		<h1 class="postTitle">
			
<a id="cb_post_title_url" class="postTitle2 vertical-middle" href="https://www.cnblogs.com/simple1025/p/11151882.html">
    <span role="heading" aria-level="2">linux上执行mysql的脚本文件</span>
    
</a>

		</h1>
		<div class="clear"></div>
		<div class="postBody">
			<div id="cnblogs_post_body" class="blogpost-body blogpost-body-html">
<p>我们测试过程中，经常需要执行升级脚本或导入生产测试数据，对于轻量的升级脚本可以直接在客户端工具中打开执行，但是对于文件内容比较大的.sql文件，比如几百M，几G的sql文件，直接拖到客户端工具打开执行，执行速度非常的慢，而且工具可能会直接卡死，甚至整个电脑都处于不可操作的状态，严重的影响工作效率，这个情况，我们可以在数据库服务器上通过命令的方式来执行sql文件， 执行速度快，且不影响客户端的操作，方法如下：</p>
<p>1、把需要执行的sql文件上传到数据库服务器指定，目录，如/data</p>
<p>2、通过linux客户端工具连接进入数据库服务器</p>
<p>3、连接数据库</p>
<p>&nbsp; &nbsp; # mysql -h IP -u root -p</p>
<p>&nbsp;<em>&nbsp; （如）#&nbsp; mysql -h 192.168.101.100 -u root -p</em></p>
<p>&nbsp; &nbsp;连接成功后，输入密码</p>
<p>4、指定数据库</p>
<p>&nbsp; # use db;</p>
<p>5、执行脚本</p>
<p>&nbsp; # source /data/执行的sql文件</p>
<p>&nbsp; <em>（如）# source /data/test190708.sql</em></p>
<p>具体操作如下图所示：</p>
<p><img src="./linux上执行mysql的脚本文件_files/1728242-20190708154429285-128638158.png" alt="" class="medium-zoom-image"></p>
<p>&nbsp;</p>
</div>
<div id="MySignature" role="contentinfo">
    作者：simplesally
出处：https://www.cnblogs.com/simple1025/
说明：本文版权归作者和博客园共有，欢迎转载和提出建议，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接，否则保留追究法律责任的权利。
</div>
<div class="clear"></div>
<div id="blog_post_info_block" role="contentinfo"><div id="BlogPostCategory">
    分类: 
            <a href="https://www.cnblogs.com/simple1025/category/1492377.html" target="_blank">测试笔记-数据库</a></div>


    <div id="blog_post_info">
<div id="green_channel">
        <a href="javascript:void(0);" id="green_channel_digg" onclick="DiggIt(11151882,cb_blogId,1);green_channel_success(this,&#39;谢谢推荐！&#39;);">好文要顶</a>
        <a id="green_channel_follow" onclick="follow(&#39;e8b7f07e-0cd7-4d0f-433d-08d6f93321fd&#39;);" href="javascript:void(0);">关注我</a>
    <a id="green_channel_favorite" onclick="AddToWz(cb_entryId);return false;" href="javascript:void(0);">收藏该文</a>
    <a id="green_channel_weibo" href="javascript:void(0);" title="分享至新浪微博" onclick="ShareToTsina()"><img src="./linux上执行mysql的脚本文件_files/icon_weibo_24.png" alt=""></a>
    <a id="green_channel_wechat" href="javascript:void(0);" title="分享至微信" onclick="shareOnWechat()"><img src="./linux上执行mysql的脚本文件_files/wechat.png" alt=""></a>
</div>
<div id="author_profile">
    <div id="author_profile_info" class="author_profile_info">
            <a href="https://home.cnblogs.com/u/simple1025/" target="_blank"><img src="./linux上执行mysql的脚本文件_files/20190628160720.png" class="author_avatar" alt=""></a>
        <div id="author_profile_detail" class="author_profile_info">
            <a href="https://home.cnblogs.com/u/simple1025/">simplesally</a><br>
            <a href="https://home.cnblogs.com/u/simple1025/followers/">粉丝 - <span class="follower-count">3</span></a>
            <a href="https://home.cnblogs.com/u/simple1025/followees/">关注 - <span class="following-count">0</span></a><br>
        </div>
    </div>
    <div class="clear"></div>
    <div id="author_profile_honor"></div>
    <div id="author_profile_follow" class="follow-tip">
                <a href="javascript:void(0);" onclick="follow(&#39;e8b7f07e-0cd7-4d0f-433d-08d6f93321fd&#39;);return false;">+加关注</a>
    </div>
</div>
<div id="div_digg">
    <div class="diggit" onclick="votePost(11151882,&#39;Digg&#39;)">
        <span class="diggnum" id="digg_count">0</span>
    </div>
    <div class="buryit" onclick="votePost(11151882,&#39;Bury&#39;)">
        <span class="burynum" id="bury_count">0</span>
    </div>
    <div class="clear"></div>
    <div class="diggword" id="digg_tips">
    </div>
</div>

<script type="text/javascript">
    currentDiggType = 0;
</script></div>
    <div class="clear"></div>
    <div id="post_next_prev">

    <a href="https://www.cnblogs.com/simple1025/p/11149838.html" class="p_n_p_prefix">« </a> 上一篇：    <a href="https://www.cnblogs.com/simple1025/p/11149838.html" data-featured-image="" title="发布于 2019-07-08 10:55">服务端接口测试分析要点</a>
    <br>
    <a href="https://www.cnblogs.com/simple1025/p/11190458.html" class="p_n_p_prefix">» </a> 下一篇：    <a href="https://www.cnblogs.com/simple1025/p/11190458.html" data-featured-image="" title="发布于 2019-07-16 17:58">jmeter连接mysql数据库</a>

</div>
</div>
		</div>
		<div class="postDesc">posted @ 
<span id="post-date">2019-07-08 16:11</span>&nbsp;
<a href="https://www.cnblogs.com/simple1025/">simplesally</a>&nbsp;
阅读(<span id="post_view_count">17573</span>)&nbsp;
评论(<span id="post_comment_count">0</span>)&nbsp;
<a href="https://i.cnblogs.com/EditPosts.aspx?postid=11151882" rel="nofollow">编辑</a>&nbsp;
<a href="javascript:void(0)" onclick="AddToWz(11151882);return false;">收藏</a>&nbsp;
<a href="javascript:void(0)" onclick="reportManager.report({ currentUserId: &#39;&#39;, targetType: &#39;blogPost&#39;, targetId: &#39;11151882&#39;, targetLink: &#39;https://www.cnblogs.com/simple1025/p/11151882.html&#39;, title: &#39;linux上执行mysql的脚本文件&#39; })">举报</a></div>
	</div>
	
	
</div><!--end: topics 文章、评论容器-->

<script>
    var cb_entryId = 11151882, cb_entryCreatedDate = '2019-07-08 16:11', cb_postType = 1, cb_postTitle = 'linux上执行mysql的脚本文件';
    var allowComments = true, cb_blogId = 524061, cb_blogApp = 'simple1025', cb_blogUserGuid = 'e8b7f07e-0cd7-4d0f-433d-08d6f93321fd';
    mermaidRender.render()
    markdown_highlight()
    zoomManager.apply("#cnblogs_post_body img:not(.code_img_closed):not(.code_img_opened)");
    updatePostStats(
            [cb_entryId],
            function(id, count) { $("#post_view_count").text(count) },
            function(id, count) { $("#post_comment_count").text(count) })
</script>
<a id="!comments"></a>
<div id="blog-comments-placeholder"></div>
<div id="comment_form" class="commentform">
    <a name="commentform"></a>
    <div id="divCommentShow"></div>
    <div id="comment_nav"><span id="span_refresh_tips"></span><a href="javascript:void(0);" onclick="return RefreshCommentList();" id="lnk_RefreshComments" runat="server" clientidmode="Static">刷新评论</a><a href="https://www.cnblogs.com/simple1025/p/11151882.html#" onclick="return RefreshPage();">刷新页面</a><a href="https://www.cnblogs.com/simple1025/p/11151882.html#top">返回顶部</a></div>
    <div id="comment_form_container" style="visibility: visible;"><div class="login_tips">
    登录后才能查看或发表评论，立即 <a rel="nofollow" href="javascript:void(0);" class="underline" onclick="return account.login(&#39;!comments&#39;);">登录</a> 或者
    <a href="https://www.cnblogs.com/">逛逛</a> 博客园首页
</div>
</div>
    <div class="ad_text_commentbox" id="ad_text_under_commentbox"></div>
        <div id="cnblogs_ch"><a href="https://curl.qcloud.com/k19RDMHo" target="_blank" onclick="gtag(&#39;event&#39;, &#39;click&#39;, {&#39;event_category&#39;: &#39;ad&#39;, &#39;event_label&#39;: &#39;T2-腾讯云&#39;})">【推荐】腾讯云多款云产品1折起，买云服务器送免费机器</a><br><a href="https://click.ctyun.cn/?track=source_bokeyuan-medium_cps-content_se430382" target="_blank" onclick="gtag(&#39;event&#39;, &#39;click&#39;, {&#39;event_category&#39;: &#39;ad&#39;, &#39;event_label&#39;: &#39;T2-天翼云&#39;})">【推荐】天翼云新客特惠，云主机1核2G低至33.43元/年</a><br></div>
    <div id="opt_under_post"></div>
    <div id="cnblogs_c1" class="under-post-card">
            <div id="div-gpt-ad-1592365906576-0" style="width: 300px; height: 250px;" data-google-query-id="CKbs8dzx-voCFQsOXAodj6oJqw"><div id="google_ads_iframe_/1090369/C1_0__container__" style="border: 0pt none; display: inline-block; width: 300px; height: 250px;"><iframe frameborder="0" src="./linux上执行mysql的脚本文件_files/container.html" id="google_ads_iframe_/1090369/C1_0" title="3rd party ad content" name="" scrolling="no" marginwidth="0" marginheight="0" width="300" height="250" data-is-safeframe="true" sandbox="allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation" role="region" aria-label="Advertisement" tabindex="0" data-google-container-id="1" style="border: 0px; vertical-align: bottom;" data-load-complete="true"></iframe></div></div>
    </div>
    <div id="under_post_card1"><div class="under-post-card">
<b>编辑推荐：</b>
<br>

· <a href="https://www.cnblogs.com/dino623/p/iPhone14ProTextAnimation.html" target="_blank">[WPF] 抄抄超强的苹果官网滚动文字特效实现</a>
    <br>
· <a href="https://www.cnblogs.com/sheng-jie/p/MassTransit-NET-Distributed-Application-Framework.html" target="_blank">MassTransit | .NET 分布式应用框架</a>
    <br>
· <a href="https://www.cnblogs.com/god23bin/p/check-duplication-in-java.html" target="_blank">查重原来是这样实现的啊！</a>
    <br>
· <a href="https://www.cnblogs.com/Finley/p/16812713.html" target="_blank">从小白到架构师(2): 走向微服务</a>
    <br>
· <a href="https://www.cnblogs.com/coco1s/p/16808899.html" target="_blank">超强的苹果官网滚动文字特效实现</a>
    <br>
</div></div>
    <div id="under_post_card2"><div class="itnews under-post-card">
    <b>最新新闻</b>：
    <br>
 ·          <a href="https://news.cnblogs.com/n/730416/" target="_blank">赛力斯：拟以自有资金不超过4亿元回购公司股份</a>
        <br>
 ·          <a href="https://news.cnblogs.com/n/730415/" target="_blank">特斯拉客服回应Model 3、Model Y降价：已下单未提车可选官网价</a>
        <br>
 ·          <a href="https://news.cnblogs.com/n/730414/" target="_blank">我做一年场控，想理解女主播的人生</a>
        <br>
 ·          <a href="https://news.cnblogs.com/n/730413/" target="_blank">韩版腾讯的一场大火，让韩国沦陷了整整4天</a>
        <br>
 ·          <a href="https://news.cnblogs.com/n/730412/" target="_blank">为什么美国没有李佳琦，中国容不下买手制？</a>
        <br>
    » <a href="https://news.cnblogs.com/" title="IT 新闻" target="_blank">更多新闻...</a>
</div></div>
    <div id="HistoryToday" class="under-post-card"></div>
    <script type="text/javascript">
        var commentManager = new blogCommentManager();
        commentManager.renderComments(0);
        fixPostBody();

            window.tocManager.displayDisableTocTips = false;
            window.tocManager.generateToc();
            
                setTimeout(function() { countViews(cb_blogId, cb_entryId); }, 50);
            
            deliverT2();
            deliverC1C2();
            loadNewsAndKb();
            
                LoadPostCategoriesTags(cb_blogId, cb_entryId);
            
            LoadPostInfoBlock(cb_blogId, cb_entryId, cb_blogApp, cb_blogUserGuid);
            GetPrevNextPost(cb_entryId, cb_blogId, cb_entryCreatedDate, cb_postType);
            loadOptUnderPost();
            GetHistoryToday(cb_blogId, cb_blogApp, cb_entryCreatedDate);
                </script>
</div>

</div>


	</div><!--end: topicList 文章列表容器-->

	<div id="sideBar">
		<div id="sideBarMain">
			<div id="sidebar_news" class="newsItem"><!--done-->
<div class="newsItem">
<h3 class="catListTitle">公告</h3>
	
<div id="blog-news">
    
    <div id="profile_block">
        昵称：
        <a href="https://home.cnblogs.com/u/simple1025/">
            simplesally
        </a>
        <br>
        园龄：
        <a href="https://home.cnblogs.com/u/simple1025/" title="入园时间：2019-06-28">
            3年3个月
        </a>
        <br>
        粉丝：
        <a class="follower-count" href="https://home.cnblogs.com/u/simple1025/followers/">
            3
        </a>
        <br>
        关注：
        <a class="folowing-count" href="https://home.cnblogs.com/u/simple1025/followees/">
            0
        </a>
        <div id="p_b_follow" class="follow-tip">
<a href="javascript:void(0)" onclick="follow(&#39;e8b7f07e-0cd7-4d0f-433d-08d6f93321fd&#39;)">+加关注</a></div>
        <script>getFollowStatus('e8b7f07e-0cd7-4d0f-433d-08d6f93321fd');</script>
    </div>
</div>
</div>

</div>
<div id="sidebar_c3"></div>
			<div id="calendar"><div id="calendar"><div id="blog-calendar" style="">

<table id="blogCalendar" class="Cal" cellspacing="0" cellpadding="0" title="Calendar" border="0">
    <tbody>
        <tr>
            <td colspan="7">
                <table class="CalTitle" cellspacing="0" border="0">
                    <tbody>
                        <tr>
                            <td class="CalNextPrev">
                                <a href="javascript:void(0);" onclick="loadBlogCalendar(&#39;2022/09/25&#39;); return false;">&lt;</a>
                            </td>
                            <td align="center">2022年10月</td>
                            <td align="right" class="CalNextPrev">
                                <a href="javascript:void(0);" onclick="loadBlogCalendar(&#39;2022/11/25&#39;); return false;">&gt;</a>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </td>
        </tr>
    <tr>
        <th class="CalDayHeader" align="center" abbr="日" scope="col">日</th>
        <th class="CalDayHeader" align="center" abbr="一" scope="col">一</th>
        <th class="CalDayHeader" align="center" abbr="二" scope="col">二</th>
        <th class="CalDayHeader" align="center" abbr="三" scope="col">三</th>
        <th class="CalDayHeader" align="center" abbr="四" scope="col">四</th>
        <th class="CalDayHeader" align="center" abbr="五" scope="col">五</th>
        <th class="CalDayHeader" align="center" abbr="六" scope="col">六</th>
    </tr>
            <tr>
                            <td class="CalOtherMonthDay" align="center">25</td>
                            <td class="CalOtherMonthDay" align="center">26</td>
                            <td class="CalOtherMonthDay" align="center">27</td>
                            <td class="CalOtherMonthDay" align="center">28</td>
                            <td class="CalOtherMonthDay" align="center">29</td>
                            <td class="CalOtherMonthDay" align="center">30</td>
                    <td class="CalWeekendDay" align="center">
                        1
                    </td>
            </tr>
                <tr>
                        <td class="CalWeekendDay" align="center">
                            2
                        </td>
                            <td class="" align="center">
                                3
                            </td>
                            <td class="" align="center">
                                4
                            </td>
                            <td class="" align="center">
                                5
                            </td>
                            <td class="" align="center">
                                6
                            </td>
                            <td class="" align="center">
                                7
                            </td>
                        <td class="CalWeekendDay" align="center">
                            8
                        </td>
                </tr>
                <tr>
                        <td class="CalWeekendDay" align="center">
                            9
                        </td>
                            <td class="" align="center">
                                10
                            </td>
                            <td class="" align="center">
                                11
                            </td>
                            <td class="" align="center">
                                12
                            </td>
                            <td class="" align="center">
                                13
                            </td>
                            <td class="" align="center">
                                14
                            </td>
                        <td class="CalWeekendDay" align="center">
                            15
                        </td>
                </tr>
                <tr>
                        <td class="CalWeekendDay" align="center">
                            16
                        </td>
                            <td class="" align="center">
                                17
                            </td>
                            <td class="" align="center">
                                18
                            </td>
                            <td class="" align="center">
                                19
                            </td>
                            <td class="" align="center">
                                20
                            </td>
                            <td class="" align="center">
                                21
                            </td>
                        <td class="CalWeekendDay" align="center">
                            22
                        </td>
                </tr>
                <tr>
                        <td class="CalWeekendDay" align="center">
                            23
                        </td>
                            <td class="" align="center">
                                24
                            </td>
                            <td class="CalTodayDay" align="center">
                                25
                            </td>
                            <td class="" align="center">
                                26
                            </td>
                            <td class="" align="center">
                                27
                            </td>
                            <td class="" align="center">
                                28
                            </td>
                        <td class="CalWeekendDay" align="center">
                            29
                        </td>
                </tr>
                <tr>
                        <td class="CalWeekendDay" align="center">
                            30
                        </td>
                            <td class="" align="center">
                                31
                            </td>
                            <td class="CalOtherMonthDay" align="center">
                                1
                            </td>
                            <td class="CalOtherMonthDay" align="center">
                                2
                            </td>
                            <td class="CalOtherMonthDay" align="center">
                                3
                            </td>
                            <td class="CalOtherMonthDay" align="center">
                                4
                            </td>
                        <td class="CalOtherMonthDay" align="center">
                            5
                        </td>
                </tr>
    </tbody>
</table></div></div>                
                    <script>loadBlogDefaultCalendar();</script></div>
			
			<div id="leftcontentcontainer">
				<div id="blog-sidecolumn"><!-- 搜索 -->
<div id="sidebar_search" class="sidebar-block">
    <div id="sidebar_search" class="mySearch">
        <h3 class="catListTitle">搜索</h3>
        <div id="sidebar_search_box">
            <div id="widget_my_zzk" class="div_my_zzk">
                <input type="text" id="q" onkeydown="return zzk_go_enter(event);" class="input_my_zzk">&nbsp;<input onclick="zzk_go()" type="button" value="找找看" id="btnZzk" class="btn_my_zzk">
            </div>
            <div id="widget_my_google" class="div_my_zzk">
                <input type="text" name="google_q" id="google_q" onkeydown="return google_go_enter(event);" class="input_my_zzk">&nbsp;<input onclick="google_go()" type="button" value="谷歌搜索" class="btn_my_zzk">
            </div>
        </div>
    </div>
</div>

<!-- 常用链接 -->
<div id="sidebar_shortcut" class="sidebar-block"><div class="catListLink">
<h3 class="catListTitle">
常用链接
</h3>
<ul>
<li><a href="https://www.cnblogs.com/simple1025/p/" title="我的博客的随笔列表">我的随笔</a></li>
<li><a href="https://www.cnblogs.com/simple1025/MyComments.html" title="我的发表过的评论列表">我的评论</a></li>
<li><a href="https://www.cnblogs.com/simple1025/OtherPosts.html" title="我评论过的随笔列表">我的参与</a></li>
<li><a href="https://www.cnblogs.com/simple1025/comments" title="我的博客的评论列表">最新评论</a></li>
<li><a href="https://www.cnblogs.com/simple1025/tag/" title="我的博客的标签列表">我的标签</a></li>

<li><a id="itemListLink" onclick="this.blur();WarpClass(&#39;itemListLink&#39;, &#39;itemListLin_con&#39;);return false;" href="https://www.cnblogs.com/simple1025/p/11151882.html#">更多链接</a></li>
</ul>
</div>

</div>

<!-- 最新随笔 -->


<!-- 我的标签 -->
<div id="sidebar_toptags" class="sidebar-block"></div>

<!-- 积分与排名 -->


<!-- 随笔分类、随笔档案、文章分类、新闻分类、相册、链接 -->
<div id="sidebar_categories">    <div class="catListPostCategory">
        <h3 class="catListTitle">
            
    <a class="sidebar-card-title-a" href="https://www.cnblogs.com/simple1025/categories">随笔分类</a>



        </h3>

        <ul>
                <li data-category-list-item-visible="true" style="display: block">
                    
<a href="https://www.cnblogs.com/simple1025/category/1492362.html" class="category-item-link" rel="" target="">测试笔记-jmeter(3)</a>

                </li>
                <li data-category-list-item-visible="true" style="display: block">
                    
<a href="https://www.cnblogs.com/simple1025/category/1492379.html" class="category-item-link" rel="" target="">测试笔记-linux(1)</a>

                </li>
                <li data-category-list-item-visible="true" style="display: block">
                    
<a href="https://www.cnblogs.com/simple1025/category/1492363.html" class="category-item-link" rel="" target="">测试笔记-web端测试(1)</a>

                </li>
                <li data-category-list-item-visible="true" style="display: block">
                    
<a href="https://www.cnblogs.com/simple1025/category/1492380.html" class="category-item-link" rel="" target="">测试笔记-接口测试(1)</a>

                </li>
                <li data-category-list-item-visible="true" style="display: block">
                    
<a href="https://www.cnblogs.com/simple1025/category/1492420.html" class="category-item-link" rel="" target="">测试笔记-其他(1)</a>

                </li>
                <li data-category-list-item-visible="true" style="display: block">
                    
<a href="https://www.cnblogs.com/simple1025/category/1492377.html" class="category-item-link" rel="" target="">测试笔记-数据库(6)</a>

                </li>
            
        </ul>
    </div>
    <div class="catListPostArchive">
        <h3 class="catListTitle">
            
随笔档案


        </h3>

        <ul>
                <li data-category-list-item-visible="true" style="display: block">
                    
<a href="https://www.cnblogs.com/simple1025/archive/2020/12.html" class="category-item-link" rel="" target="">2020年12月(1)</a>

                </li>
                <li data-category-list-item-visible="true" style="display: block">
                    
<a href="https://www.cnblogs.com/simple1025/archive/2019/08.html" class="category-item-link" rel="" target="">2019年8月(5)</a>

                </li>
                <li data-category-list-item-visible="true" style="display: block">
                    
<a href="https://www.cnblogs.com/simple1025/archive/2019/07.html" class="category-item-link" rel="" target="">2019年7月(6)</a>

                </li>
                <li data-category-list-item-visible="true" style="display: block">
                    
<a href="https://www.cnblogs.com/simple1025/archive/2019/06.html" class="category-item-link" rel="" target="">2019年6月(2)</a>

                </li>
            
        </ul>
    </div>
</div>

<!-- 最新评论 -->
<!-- 阅读排行榜 -->
<div id="sidebar_topviewedposts" class="sidebar-block"><div class="catListView">
    <h3 class="catListTitle">
        <a href="https://www.cnblogs.com/simple1025/most-viewed" class="sidebar-card-title-a">
    阅读排行榜
</a>

    </h3>
    <div id="TopViewPostsBlock">
        <ul style="word-break:break-all">
                    <li>
                        <a href="https://www.cnblogs.com/simple1025/p/11151882.html">
                            1. linux上执行mysql的脚本文件(17573)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/simple1025/p/11133538.html">
                            2. linux服务器上安装mysql(17172)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/simple1025/p/11297284.html">
                            3. mysql应用之通过存储过程方式批量插入数据(11876)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/simple1025/p/11107652.html">
                            4. web端测试的测试点和注意事项(6083)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/simple1025/p/11149838.html">
                            5. 服务端接口测试分析要点(3396)
                        </a>
                    </li>
        </ul>
    </div>
</div></div>

<!-- 评论排行榜 -->
<div id="sidebar_topcommentedposts" class="sidebar-block"><div class="catListFeedback">
    <h3 class="catListTitle">
        <a href="https://www.cnblogs.com/simple1025/most-commented" class="sidebar-card-title-a">评论排行榜</a>

    </h3>
    <div id="TopFeedbackPostsBlock">
        <ul style="word-break:break-all">
                    <li>
                        <a href="https://www.cnblogs.com/simple1025/p/11133538.html">
                            1. linux服务器上安装mysql(7)
                        </a>
                    </li>
                    <li>
                        <a href="https://www.cnblogs.com/simple1025/p/11107652.html">
                            2. web端测试的测试点和注意事项(3)
                        </a>
                    </li>
        </ul>
    </div>
</div></div>

<!-- 推荐排行榜 -->
<div id="sidebar_topdiggedposts" class="sidebar-block">
<div id="topdigg_posts_wrap">
    <div class="catListView">
        <h3 class="catListTitle">
            <a href="https://www.cnblogs.com/simple1025/most-liked" class="sidebar-card-title-a">推荐排行榜</a>

        </h3>
        <div id="TopDiggPostsBlock">
            <ul style="word-break: break-all">
                        <li>
                            <a href="https://www.cnblogs.com/simple1025/p/11107652.html">
                                1. web端测试的测试点和注意事项(3)
                            </a>
                        </li>
                        <li>
                            <a href="https://www.cnblogs.com/simple1025/p/11127436.html">
                                2. mysql数据库监控工具-MONyog的配置和基本使用项(1)
                            </a>
                        </li>
                        <li>
                            <a href="https://www.cnblogs.com/simple1025/p/11104272.html">
                                3. JVM可视化监控工具jconsole以及jvisualvm的配置(1)
                            </a>
                        </li>
            </ul>
        </div>
    </div>
</div></div><div id="sidebar_recentcomments" class="sidebar-block"><div class="catListComment">
<h3 class="catListTitle"><a href="https://www.cnblogs.com/simple1025/comments" class="sidebar-card-title-a">最新评论</a></h3>
    <div class="RecentCommentBlock">
        <ul>
                <li class="recent_comment_title"><a href="https://www.cnblogs.com/simple1025/p/11133538.html">1. Re:linux服务器上安装mysql</a></li>
                <li class="recent_comment_body"><p>这个mysql包在哪里下载呀</p>
</li>
                <li class="recent_comment_author">--筱忆她</li>
                <li class="recent_comment_title"><a href="https://www.cnblogs.com/simple1025/p/11133538.html">2. Re:linux服务器上安装mysql</a></li>
                <li class="recent_comment_body">@吃鲸的猫 第五步： [root@localhost scripts]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --da...</li>
                <li class="recent_comment_author">--simplesally</li>
                <li class="recent_comment_title"><a href="https://www.cnblogs.com/simple1025/p/11133538.html">3. Re:linux服务器上安装mysql</a></li>
                <li class="recent_comment_body"><p>麻烦问一下怎么执行mysql_install_db脚本？双击吗</p>
</li>
                <li class="recent_comment_author">--吃鲸的猫</li>
                <li class="recent_comment_title"><a href="https://www.cnblogs.com/simple1025/p/11133538.html">4. Re:linux服务器上安装mysql</a></li>
                <li class="recent_comment_body">@simplesally 我下载安装包下错了，准备重新下载试试，谢谢您...</li>
                <li class="recent_comment_author">--吃鲸的猫</li>
                <li class="recent_comment_title"><a href="https://www.cnblogs.com/simple1025/p/11133538.html">5. Re:linux服务器上安装mysql</a></li>
                <li class="recent_comment_body">@吃鲸的猫 检查是不是空格不对，我复制您的命令出来看，是空格不对，试下： cp support-files/mysql.server /etc/init.d/mysqld...</li>
                <li class="recent_comment_author">--simplesally</li>
        </ul>
    </div>
</div>

</div>


</div>
                    <script>loadBlogSideColumn();</script>
			</div>
			
		</div><!--end: sideBarMain -->
		<div class="clear"></div>
		<div id="footer">
			<!--done-->
Copyright © 2022 simplesally
<br><span id="poweredby">Powered by .NET 6 on Kubernetes</span>



		</div><!--end: footer -->
	</div><!--end: sideBar 侧边栏容器 -->
</div><!--end: home 自定义的最大容器 -->
</center>





<input type="hidden" id="antiforgery_token" value="CfDJ8NfDHj8mnYFAmPyhfXwJojdVlIq_J7MPcSX2BFqyFE3e5pn_KXWJQjxUp9qPhUt_knm7xPawjvYJL48IjadkWlMkCLYx7OgttMFviOrSQO1IJLADA7nouUuz056eF_4bQ3WGSSbPIPiGDSo9abMXrHo">
<script async="" src="./linux上执行mysql的脚本文件_files/js"></script>
<script>
    window.dataLayer = window.dataLayer || [];
    function gtag(){dataLayer.push(arguments);}
    gtag('js', new Date());
    var kv = getGACustom();
    if (kv) {
        gtag('set', kv);
    }
    gtag('config', 'UA-476124-1');
</script>
<script defer="" src="./linux上执行mysql的脚本文件_files/hm.js"></script><iframe src="./linux上执行mysql的脚本文件_files/container(1).html" style="visibility: hidden; display: none;"></iframe>

<iframe src="./linux上执行mysql的脚本文件_files/aframe.html" width="0" height="0" style="display: none;"></iframe></body></html>